package contract;

public class ContractDTO {
	
	private String ct_no;			//계약번호
	private String cs_no;			//상담번호
	private String ap_no;			//결재번호
	private String ct_ing;			//계약상태
	private String cs_pay_dt;		//돈 빌려주는 날
	private String pd_pback;		//납입구분코드
	private String pd_rate;			//금리
	private String cs_loan;			//대출액
	private String cs_loan_start;	//대출시작일(초회납입일)
	private String pd_prd;			//상환기간
	private String cs_loan_end;		//대출만기일
	private String ct_end_dt;		//계약 만료일
	private String rg_pp;			//최초 등록자
	private String rg_dt;			//최초 등록일
	private String md_pp;			//최종 수정자
	private String md_dt;			//최종 수정일
	
	private String rg_pp_nm;		//담당자 이름 (가상 컬럼)
	private String md_pp_nm;		//승인자 이름 (가상 컬럼)
	
	//다른 테이블 컬럼 화면 표시용 변수
	private String sa_no;			//사원번호
	private String sa_nm;			//사원명
	private String pd_no;			//상품번호
	private String pd_nm;			//상품명
	private String sa_dpm;			//부서명
	private String sa_gd;			//직급
	private String sa_email;		//이메일
	private String sa_ph;			//연락처
	private String sa_bknm;			//은행명
	private String sa_acc;			//계좌번호
	private String cs_max;			//개인 대출한도액
	
	//검색용 변수
	private String sa_search;//사원명인지 사원번호인지
	private String pd_search;//상품명인지 상품번호인지
	private String ct_search;//계약번호 인지 상담번호인지 담당자인지
	private String cs_sd;//상담일검색 시작일
	private String cs_ed;//상담일검색 마지막일
	private String full;//검색인지 아닌지 구분하기 위해
	
	//기본 생성자
	public ContractDTO() {}

	//insert용 생성자
	public ContractDTO(String ct_no, String cs_no, String ct_ing, String pd_pback, 
			String pd_rate, String cs_loan, String pd_prd, String rg_pp, String md_pp) {
		this.ct_no = ct_no;
		this.cs_no = cs_no;
		this.ct_ing = ct_ing;
		this.pd_pback = pd_pback;
		this.pd_rate = pd_rate;
		this.cs_loan = cs_loan;
		this.pd_prd = pd_prd;
		this.rg_pp = rg_pp;
		this.md_pp = md_pp;
	}
	
	//update용 생성자
	public ContractDTO(String ct_no, String pd_pback, String pd_rate,
			String cs_loan, String pd_prd, String md_pp, String ct_ing) {
		this.ct_no = ct_no;
		this.pd_pback = pd_pback;
		this.pd_rate = pd_rate;
		this.cs_loan = cs_loan;
		this.pd_prd = pd_prd;
		this.md_pp = md_pp;
		this.ct_ing = ct_ing;
	}
	
	//getter/setter
	public String getCt_no() {
		return ct_no;
	}
	public void setCt_no(String ct_no) {
		this.ct_no = ct_no;
	}
	public String getCs_no() {
		return cs_no;
	}
	public void setCs_no(String cs_no) {
		this.cs_no = cs_no;
	}
	public String getAp_no() {
		return ap_no;
	}
	public void setAp_no(String ap_no) {
		this.ap_no = ap_no;
	}
	public String getCt_ing() {
		return ct_ing;
	}
	public void setCt_ing(String ct_ing) {
		this.ct_ing = ct_ing;
	}
	public String getCs_pay_dt() {
		return cs_pay_dt;
	}
	public void setCs_pay_dt(String cs_pay_dt) {
		this.cs_pay_dt = cs_pay_dt;
	}
	public String getPd_pback() {
		return pd_pback;
	}
	public void setPd_pback(String pd_pback) {
		this.pd_pback = pd_pback;
	}
	public String getPd_rate() {
		return pd_rate;
	}
	public void setPd_rate(String pd_rate) {
		this.pd_rate = pd_rate;
	}
	public String getCs_loan() {
		return cs_loan;
	}
	public void setCs_loan(String cs_loan) {
		this.cs_loan = cs_loan;
	}
	public String getCs_loan_start() {
		return cs_loan_start;
	}
	public void setCs_loan_start(String cs_loan_start) {
		this.cs_loan_start = cs_loan_start;
	}
	public String getPd_prd() {
		return pd_prd;
	}
	public void setPd_prd(String pd_prd) {
		this.pd_prd = pd_prd;
	}
	public String getCs_loan_end() {
		return cs_loan_end;
	}
	public void setCs_loan_end(String cs_loan_end) {
		this.cs_loan_end = cs_loan_end;
	}
	public String getRg_pp() {
		return rg_pp;
	}
	public void setRg_pp(String rg_pp) {
		this.rg_pp = rg_pp;
	}
	public String getRg_dt() {
		return rg_dt;
	}
	public void setRg_dt(String rg_dt) {
		this.rg_dt = rg_dt;
	}
	public String getMd_pp() {
		return md_pp;
	}
	public void setMd_pp(String md_pp) {
		this.md_pp = md_pp;
	}
	public String getMd_dt() {
		return md_dt;
	}
	public void setMd_dt(String md_dt) {
		this.md_dt = md_dt;
	}

	//다른 테이블 컬럼 화면 표시용 getter/setter
	public String getSa_no() {
		return sa_no;
	}
	public void setSa_no(String sa_no) {
		this.sa_no = sa_no;
	}
	public String getSa_nm() {
		return sa_nm;
	}
	public void setSa_nm(String sa_nm) {
		this.sa_nm = sa_nm;
	}
	public String getPd_no() {
		return pd_no;
	}
	public void setPd_no(String pd_no) {
		this.pd_no = pd_no;
	}
	public String getPd_nm() {
		return pd_nm;
	}
	public void setPd_nm(String pd_nm) {
		this.pd_nm = pd_nm;
	}
	public String getSa_dpm() {
		return sa_dpm;
	}
	public void setSa_dpm(String sa_dpm) {
		this.sa_dpm = sa_dpm;
	}
	public String getSa_gd() {
		return sa_gd;
	}
	public void setSa_gd(String sa_gd) {
		this.sa_gd = sa_gd;
	}
	public String getSa_email() {
		return sa_email;
	}
	public void setSa_email(String sa_email) {
		this.sa_email = sa_email;
	}
	public String getSa_ph() {
		return sa_ph;
	}
	public void setSa_ph(String sa_ph) {
		this.sa_ph = sa_ph;
	}
	public String getSa_bknm() {
		return sa_bknm;
	}
	public void setSa_bknm(String sa_bknm) {
		this.sa_bknm = sa_bknm;
	}
	public String getSa_acc() {
		return sa_acc;
	}
	public void setSa_acc(String sa_acc) {
		this.sa_acc = sa_acc;
	}

	//검색용 getter/setter
	public String getSa_search() {
		return sa_search;
	}
	public void setSa_search(String sa_search) {
		this.sa_search = sa_search;
	}
	public String getPd_search() {
		return pd_search;
	}
	public void setPd_search(String pd_search) {
		this.pd_search = pd_search;
	}
	public String getCt_search() {
		return ct_search;
	}
	public void setCt_search(String ct_search) {
		this.ct_search = ct_search;
	}
	public String getCs_sd() {
		return cs_sd;
	}
	public void setCs_sd(String cs_sd) {
		this.cs_sd = cs_sd;
	}
	public String getCs_ed() {
		return cs_ed;
	}
	public void setCs_ed(String cs_ed) {
		this.cs_ed = cs_ed;
	}
	public String getFull() {
		return full;
	}
	public void setFull(String full) {
		this.full = full;
	}
	public String getRg_pp_nm() {
		return rg_pp_nm;
	}
	public void setRg_pp_nm(String rg_pp_nm) {
		this.rg_pp_nm = rg_pp_nm;
	}
	public String getMd_pp_nm() {
		return md_pp_nm;
	}
	public void setMd_pp_nm(String md_pp_nm) {
		this.md_pp_nm = md_pp_nm;
	}
	public String getCs_max() {
		return cs_max;
	}
	public void setCs_max(String cs_max) {
		this.cs_max = cs_max;
	}
	public String getCt_end_dt() {
		return ct_end_dt;
	}
	public void setCt_end_dt(String ct_end_dt) {
		this.ct_end_dt = ct_end_dt;
	}
	
}
